select distinct finger_unit.unitid as poli_rujukan,finger_unit.nopasien as id, upper(finger_unit.namapasien) as nama, upper(finger_unit.jenispasien) as jenis, upper(finger_unit.status) as statussidik,finger_unit.nourut as nourut,finger_unit.kode as kode,finger_unit.nokartu as no_kartu,finger_unit.umur as umur,concat("(",if(finger_unit.status="tidak","tidak resep", "dapat resep"),") - ",keterangan) as keterangan, flag from finger_unit inner join units on units.unit = finger_unit.poli_rujukan where units.id = "11" and substring(finger_unit.tanggalfingger,1,10) = "2023-12-11" and poli !="tidak ada" order by statussidik asc, nourut 
